-- ----------------------------- 2023-05-28 add by yuanx@sunwayworld.com--------------begin

-- 建表语句
CREATE TABLE T_LIMS_EQUIPT_FILE_ACQ( 
    ID NUMBER NOT NULL,
    CREATEDBYID VARCHAR2(36)  NULL,
    CREATEDBYNAME VARCHAR2(60)  NULL,
    CREATEDTIME DATE NULL,
    CREATEDBYORGID VARCHAR2(36)  NULL,
    CREATEDBYORGNAME VARCHAR2(270)  NULL,
    EQUIPTID NUMBER NULL,
    GAINPATH VARCHAR2(300)  NULL,
    LOCALPATH VARCHAR2(300)  NULL,
    TIMESTAMP VARCHAR2(64)  NULL,
    FILENAME VARCHAR2(150)  NULL,
    FILESIZE NUMBER NULL,
    FILEID NUMBER NULL,
    STOREFLAG VARCHAR2(3)  NULL,
    EXECTORNAME VARCHAR2(24)  NULL
 );
COMMENT ON TABLE T_LIMS_EQUIPT_FILE_ACQ IS '设备采集文件';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.ID IS '主键';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYID IS '制单人编码';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYNAME IS '制单人名称';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.CREATEDTIME IS '制单时间';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYORGID IS '制单人单位编码';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYORGNAME IS '制单人单位名称';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.EQUIPTID IS '设备id';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.GAINPATH IS '采集路径';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.LOCALPATH IS '本地路径';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.TIMESTAMP IS '文件修改时间';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.FILENAME IS '文件名';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.FILESIZE IS '文件大小';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.FILEID IS '文件id';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.STOREFLAG IS '是否上传';
COMMENT ON COLUMN T_LIMS_EQUIPT_FILE_ACQ.EXECTORNAME IS '文件采集执行器';

ALTER TABLE T_LIMS_EQUIPT_FILE_ACQ ADD CONSTRAINT PK_LIMS_EQUIPT_FILE_ACQ PRIMARY KEY (ID);

-- 旧版审计跟踪，跟踪配置变更语句

INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','ID','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYID','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYNAME','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDTIME','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYORGID','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYORGNAME','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','EQUIPTID','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','GAINPATH','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','LOCALPATH','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','TIMESTAMP','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILENAME','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILESIZE','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILEID','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','STOREFLAG','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
INSERT INTO T_CORE_AT_CONFIG_LINE (ID,CONFIGID,COLUMNID,AUDITTRAIL,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,CREATEDBYORGID,CREATEDBYORGNAME) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','EXECTORNAME','1','yuanx','袁旭', CURRENT_TIMESTAMP,'L005','五行业');
COMMIT;

-- 审计跟踪V2，跟踪配置变更语句

INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','ID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDTIME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYORGID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','CREATEDBYORGNAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','EQUIPTID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','GAINPATH','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','LOCALPATH','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','TIMESTAMP','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILENAME','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILESIZE','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','FILEID','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','STOREFLAG','1');
INSERT INTO T_CORE_AUDIT_CONFIG_COLUMN (ID,CONFIGID,"COLUMN",AUDITABLE) VALUES (SEQ_CORE.NEXTVAL,'T_LIMS_EQUIPT_FILE_ACQ','EXECTORNAME','1');
COMMIT;
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.SERVICE_NAME', '设备采集文件', '设备采集文件', 'zh-CN', '设备采集文件');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.ID', '设备采集文件的主键', '主键', 'zh-CN', '主键');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYID', '设备采集文件的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYNAME', '设备采集文件的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.CREATEDTIME', '设备采集文件的制单时间', '制单时间', 'zh-CN', '制单时间');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYORGID', '设备采集文件的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.CREATEDBYORGNAME', '设备采集文件的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.EQUIPTID', '设备采集文件的设备id', '设备id', 'zh-CN', '设备id');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.GAINPATH', '设备采集文件的采集路径', '采集路径', 'zh-CN', '采集路径');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.LOCALPATH', '设备采集文件的本地路径', '本地路径', 'zh-CN', '本地路径');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.TIMESTAMP', '设备采集文件的文件修改时间', '文件修改时间', 'zh-CN', '文件修改时间');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.FILENAME', '设备采集文件的文件名', '文件名', 'zh-CN', '文件名');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.FILESIZE', '设备采集文件的文件大小', '文件大小', 'zh-CN', '文件大小');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.FILEID', '设备采集文件的文件id', '文件id', 'zh-CN', '文件id');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.STOREFLAG', '设备采集文件的是否上传', '是否上传', 'zh-CN', '是否上传');
CALL INSERTI18N('T_LIMS_EQUIPT_FILE_ACQ.EXECTORNAME', '设备采集文件的文件采集执行器', '文件采集执行器', 'zh-CN', '文件采集执行器');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPTFILEACQS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPTFILEACQS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPTFILEACQS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPTFILEACQS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPTFILEACQS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');

-- 创建菜单语句
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('111111', '设备文件采集', '/secure/basemodule/trm/equipt/equipt-file-acqs/page/edit-list', '11', '111111', '053.svg', '设备文件采集');
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
VALUES ('111103', '设备文件采集查询', '/secure/basemodule/trm/equipt/equipt-file-acqs/page/search-list', '11', '111103', '053.svg', '设备文件采集查询');

INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
VALUES ('T_LIMS_EQUIPT_FILE_ACQ', '0', '0');


COMMIT;

-- ----------------------------- 2023-05-28 add by yuanx@sunwayworld.com------------end